﻿27.4.2013 21:05:30
select * from [User] where nameLogin = @nameLogin and password = @password

27.4.2013 21:05:37
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('27.4.2013 21:05:37', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

27.4.2013 21:05:39
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

27.4.2013 21:06:12
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

27.4.2013 21:06:31
select * from Rights where idModul = 13

27.4.2013 21:06:31
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

27.4.2013 21:07:14
UPDATE Modul SET 
nameModul = 'Testovací modul 7', 
 idParent = '0', 
 orderModul = '70', 
 sqlQuery = '', 
 nameApplication = NULL, 
 parametersApp = NULL, 
 userMod = 1, 
 dateMod = to_date('27.4.2013 21:07:14', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 26 

27.4.2013 21:07:14
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

27.4.2013 21:07:24
UPDATE Modul SET 
nameModul = 'Testovaci modul 5', 
 idParent = '0', 
 orderModul = '50', 
 sqlQuery = '', 
 nameApplication = 'Test.exe', 
 parametersApp = '-nazev=Testovaci_modul_5', 
 userMod = 1, 
 dateMod = to_date('27.4.2013 21:07:24', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 8 

27.4.2013 21:07:24
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

27.4.2013 21:07:55
select * from role order by name

27.4.2013 21:07:55
select * from role order by name

27.4.2013 21:07:55
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

27.4.2013 21:07:58
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

27.4.2013 21:07:58
select * from company order by name

27.4.2013 21:08:00
select * from role order by name

27.4.2013 21:08:00
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

27.4.2013 21:08:00
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

27.4.2013 21:08:00
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

27.4.2013 21:08:00
select * from role order by name

27.4.2013 21:08:17
UPDATE Login SET 
logout = to_date('27.4.2013 21:08:17', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 374 

27.4.2013 21:40:37
select * from [User] where nameLogin = @nameLogin and password = @password

27.4.2013 21:40:37
System.Data.SqlClient.SqlException: Cannot open user default database. Login failed.
Login failed for user 'MARIO-PC\Mario'.
   at System.Data.SqlClient.SqlInternalConnection.OnError(SqlException exception, Boolean breakConnection)
   at System.Data.SqlClient.TdsParser.ThrowExceptionAndWarning(TdsParserStateObject stateObj)
   at System.Data.SqlClient.TdsParser.Run(RunBehavior runBehavior, SqlCommand cmdHandler, SqlDataReader dataStream, BulkCopySimpleResultSet bulkCopyHandler, TdsParserStateObject stateObj)
   at System.Data.SqlClient.SqlInternalConnectionTds.CompleteLogin(Boolean enlistOK)
   at System.Data.SqlClient.SqlInternalConnectionTds.AttemptOneLogin(ServerInfo serverInfo, String newPassword, Boolean ignoreSniOpenTimeout, Int64 timerExpire, SqlConnection owningObject)
   at System.Data.SqlClient.SqlInternalConnectionTds.LoginNoFailover(String host, String newPassword, Boolean redirectedUserInstance, SqlConnection owningObject, SqlConnectionString connectionOptions, Int64 timerStart)
   at System.Data.SqlClient.SqlInternalConnectionTds.OpenLoginEnlist(SqlConnection owningObject, SqlConnectionString connectionOptions, String newPassword, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlInternalConnectionTds..ctor(DbConnectionPoolIdentity identity, SqlConnectionString connectionOptions, Object providerInfo, String newPassword, SqlConnection owningObject, Boolean redirectedUserInstance)
   at System.Data.SqlClient.SqlConnectionFactory.CreateConnection(DbConnectionOptions options, Object poolGroupProviderInfo, DbConnectionPool pool, DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionFactory.CreatePooledConnection(DbConnection owningConnection, DbConnectionPool pool, DbConnectionOptions options)
   at System.Data.ProviderBase.DbConnectionPool.CreateObject(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.UserCreateRequest(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionPool.GetConnection(DbConnection owningObject)
   at System.Data.ProviderBase.DbConnectionFactory.GetConnection(DbConnection owningConnection)
   at System.Data.ProviderBase.DbConnectionClosed.OpenConnection(DbConnection outerConnection, DbConnectionFactory connectionFactory)
   at System.Data.SqlClient.SqlConnection.Open()
   at DBManager.SqlManager.Select(String sql_, DataTable& dataTable_, Dictionary`2 parametry) in G:\ProjectsSVN\trunk\Pruzkumnik\DBManager\SqlManager.cs:line 230

27.4.2013 21:54:46
select * from [User] where nameLogin = @nameLogin and password = @password

27.4.2013 21:54:46
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('27.4.2013 21:54:46', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

27.4.2013 21:54:46
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

27.4.2013 21:54:49
select * from role order by name

27.4.2013 21:54:49
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

27.4.2013 21:54:49
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

27.4.2013 21:54:49
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

27.4.2013 21:54:49
select * from role order by name

27.4.2013 21:54:50
select * from role order by name

27.4.2013 21:54:50
select * from role order by name

27.4.2013 21:54:50
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

27.4.2013 21:55:16
select * from Rights where idModul = 11

27.4.2013 21:55:16
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

27.4.2013 21:55:41
UPDATE Modul SET 
nameModul = 'Testovací modul 7', 
 idParent = '0', 
 orderModul = '70', 
 sqlQuery = '', 
 nameApplication = 'Test.exe', 
 parametersApp = NULL, 
 userMod = 1, 
 dateMod = to_date('27.4.2013 21:55:41', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 26 

27.4.2013 21:55:41
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

27.4.2013 21:55:58
UPDATE Modul SET 
nameModul = 'Testovací modul 7', 
 idParent = '0', 
 orderModul = '70', 
 sqlQuery = '', 
 nameApplication = 'Test.exe', 
 parametersApp = '-nazev=Testovaci_modul_7', 
 userMod = 1, 
 dateMod = to_date('27.4.2013 21:55:58', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 26 

27.4.2013 21:55:58
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

27.4.2013 21:57:41
UPDATE Login SET 
logout = to_date('27.4.2013 21:57:41', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 377 

27.4.2013 21:58:04
select * from [User] where nameLogin = @nameLogin and password = @password

27.4.2013 21:58:04
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('27.4.2013 21:58:04', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

27.4.2013 21:58:04
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

27.4.2013 21:58:35
select * from Dotaznik

27.4.2013 21:58:39
UPDATE Modul SET 
nameModul = 'Testovaci modul 1', 
 idParent = '0', 
 orderModul = '10', 
 sqlQuery = 'select * from Dotaznik', 
 nameApplication = NULL, 
 parametersApp = NULL, 
 userMod = 1, 
 dateMod = to_date('27.4.2013 21:58:38', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 1 

27.4.2013 21:58:39
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

27.4.2013 21:59:02
UPDATE Login SET 
logout = to_date('27.4.2013 21:59:02', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 378 

27.4.2013 22:09:55
select * from [User] where nameLogin = @nameLogin and password = @password

27.4.2013 22:09:55
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('27.4.2013 22:09:55', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

27.4.2013 22:09:55
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

27.4.2013 22:10:08
select * from role order by name

27.4.2013 22:10:08
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

27.4.2013 22:10:08
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

27.4.2013 22:10:08
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

27.4.2013 22:10:08
select * from role order by name

27.4.2013 22:10:17
select * from role order by name

27.4.2013 22:10:17
select * from role order by name

27.4.2013 22:10:17
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

27.4.2013 22:10:19
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

27.4.2013 22:10:19
select * from company order by name

27.4.2013 22:10:21
select * from role order by name

27.4.2013 22:11:06
UPDATE Login SET 
logout = to_date('27.4.2013 22:11:06', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 382 

27.4.2013 23:39:38
select * from [User] where nameLogin = @nameLogin and password = @password

27.4.2013 23:39:38
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('27.4.2013 23:39:38', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

27.4.2013 23:39:38
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

27.4.2013 23:39:40
select * from role order by name

27.4.2013 23:39:40
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

27.4.2013 23:39:40
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

27.4.2013 23:39:40
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

27.4.2013 23:39:41
select * from role order by name

27.4.2013 23:39:43
select * from role order by name

27.4.2013 23:39:43
select * from role order by name

27.4.2013 23:39:43
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

27.4.2013 23:39:45
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

27.4.2013 23:39:45
select * from company order by name

27.4.2013 23:39:47
UPDATE Login SET 
logout = to_date('27.4.2013 23:39:47', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 386 

28.4.2013 14:57:06
select * from [User] where nameLogin = @nameLogin and password = @password

28.4.2013 14:57:06
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('28.4.2013 14:57:06', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

28.4.2013 14:57:06
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 14:57:07
select * from role order by name

28.4.2013 14:57:07
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 14:57:07
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 14:57:08
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

28.4.2013 14:57:08
select * from role order by name

28.4.2013 14:57:09
select * from role order by name

28.4.2013 14:57:09
select * from role order by name

28.4.2013 14:57:09
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

28.4.2013 14:57:10
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

28.4.2013 14:57:10
select * from company order by name

28.4.2013 14:57:11
select * from role order by name

28.4.2013 14:57:13
select * from role order by name

28.4.2013 14:57:14
select * from role order by name

28.4.2013 14:57:14
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

28.4.2013 14:57:14
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

28.4.2013 14:57:14
select * from company order by name

28.4.2013 14:57:17
UPDATE Login SET 
logout = to_date('28.4.2013 14:57:17', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 388 

28.4.2013 15:00:39
select * from [User] where nameLogin = @nameLogin and password = @password

28.4.2013 15:00:39
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('28.4.2013 15:00:39', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

28.4.2013 15:00:39
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 15:00:41
select * from role order by name

28.4.2013 15:00:41
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 15:00:41
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 15:00:41
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

28.4.2013 15:00:41
select * from role order by name

28.4.2013 15:00:42
select * from role order by name

28.4.2013 15:00:42
select * from role order by name

28.4.2013 15:00:42
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

28.4.2013 15:00:43
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

28.4.2013 15:00:43
select * from company order by name

28.4.2013 15:00:45
UPDATE Login SET 
logout = to_date('28.4.2013 15:00:45', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 391 

28.4.2013 15:11:23
select * from [User] where nameLogin = @nameLogin and password = @password

28.4.2013 15:11:23
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('28.4.2013 15:11:23', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

28.4.2013 15:11:23
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 15:11:25
select * from role order by name

28.4.2013 15:11:25
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 15:11:25
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 15:11:25
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

28.4.2013 15:11:25
select * from role order by name

28.4.2013 15:11:26
select * from role order by name

28.4.2013 15:11:26
select * from role order by name

28.4.2013 15:11:26
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

28.4.2013 15:11:27
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

28.4.2013 15:11:27
select * from company order by name

28.4.2013 15:11:28
UPDATE Login SET 
logout = to_date('28.4.2013 15:11:28', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 395 

28.4.2013 15:15:30
select * from [User] where nameLogin = @nameLogin and password = @password

28.4.2013 15:15:30
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('28.4.2013 15:15:30', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

28.4.2013 15:15:30
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 15:15:34
select * from role order by name

28.4.2013 15:15:34
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 15:15:34
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 15:15:34
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

28.4.2013 15:15:34
select * from role order by name

28.4.2013 15:15:39
select * from role order by name

28.4.2013 15:15:39
select * from role order by name

28.4.2013 15:15:39
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

28.4.2013 15:15:47
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

28.4.2013 15:15:47
select * from company order by name

28.4.2013 15:15:56
select * from role order by name

28.4.2013 15:16:09
INSERT INTO [User] ( nameLogin, 
password, 
idRole) VALUES (  'Karol', 
 'test', 
 3) ; SELECT @@Identity

28.4.2013 15:16:09
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

28.4.2013 15:16:09
select * from company order by name

28.4.2013 15:16:12
select * from company order by name

28.4.2013 15:16:27
UPDATE [User] SET 
IdCompany = NULL, 
 Notes = '', 
 Phone = '', 
 Email = '', 
 Address = '', 
 NameLogin = 'Felix', 
 Password = 'test', 
 Name = 'Karol', 
 Surname = ''
 WHERE idUser = 8 

28.4.2013 15:16:27
select [USER].*, Role.name as RoleName 
from [USER] 
left join Role on Role.idRole = [USER].idRole

28.4.2013 15:16:27
select * from company order by name

28.4.2013 15:16:27
select * from company order by name

28.4.2013 15:16:33
select * from company order by name

28.4.2013 15:16:34
select * from company order by name

28.4.2013 15:16:37
select * from role order by name

28.4.2013 15:16:37
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

28.4.2013 15:16:47
UPDATE [User] SET 
idRole = 1
 WHERE idUser = 8 

28.4.2013 15:16:47
select [User].idUser, [User].name, [User].surname, [User].nameLogin, [User].idRole  from [User] 
left join Role on Role.idRole = [User].idRole

28.4.2013 15:16:54
select * from role order by name

28.4.2013 15:17:01
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 15:17:01
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 15:17:01
--DECLARE 2 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 2 
order by modul.nameModul

28.4.2013 15:17:03
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 15:17:03
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 15:17:03
--DECLARE 3 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 3 
order by modul.nameModul

28.4.2013 15:17:04
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 15:17:04
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 15:17:04
--DECLARE 5 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 5 
order by modul.nameModul

28.4.2013 15:17:39
UPDATE Rights SET 
visible = 0, 
 adding = 0, 
 edit = 0, 
 remove = 1, 
 printing = 1, 
 specialFiltration = 1
 WHERE idRights = 1 

28.4.2013 15:18:02
select * from Dotaznik

28.4.2013 15:18:13
select top 3 * from Dotaznik

28.4.2013 15:18:43
UPDATE Modul SET 
nameModul = 'Testovaci modul 1', 
 idParent = '0', 
 orderModul = '10', 
 sqlQuery = 'select top 3 * from Dotaznik', 
 nameApplication = NULL, 
 parametersApp = NULL, 
 userMod = 1, 
 dateMod = to_date('28.4.2013 15:18:43', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 1 

28.4.2013 15:18:43
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 15:18:51
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 15:18:57
select * from Rights where idModul = 26

28.4.2013 15:18:57
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 15:19:17
UPDATE Login SET 
logout = to_date('28.4.2013 15:19:17', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 397 

28.4.2013 15:19:58
select * from [User] where nameLogin = @nameLogin and password = @password

28.4.2013 15:19:58
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('28.4.2013 15:19:58', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

28.4.2013 15:19:58
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 15:20:01
select * from role order by name

28.4.2013 15:20:01
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 15:20:01
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 15:20:01
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

28.4.2013 15:20:01
select * from role order by name

28.4.2013 15:20:07
UPDATE Rights SET 
visible = 1, 
 adding = 1, 
 edit = 1, 
 remove = 1, 
 printing = 1, 
 specialFiltration = 1
 WHERE idRights = 1 

28.4.2013 15:29:40
UPDATE Login SET 
logout = to_date('28.4.2013 15:29:40', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 398 

28.4.2013 15:35:30
select * from [User] where nameLogin = @nameLogin and password = @password

28.4.2013 15:35:30
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('28.4.2013 15:35:30', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

28.4.2013 15:35:30
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 15:35:41
UPDATE Modul SET 
nameModul = 'Testovaci modul 1', 
 idParent = '0', 
 orderModul = '10', 
 sqlQuery = 'select * from Dotaznik', 
 nameApplication = NULL, 
 parametersApp = NULL, 
 userMod = 1, 
 dateMod = to_date('28.4.2013 15:35:41', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 1 

28.4.2013 15:35:41
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 15:36:02
UPDATE Modul SET 
nameModul = 'Testovaci modul 1.1', 
 idParent = '1', 
 orderModul = '10', 
 sqlQuery = 'select top 5 * from dotaznik', 
 nameApplication = NULL, 
 parametersApp = NULL, 
 userMod = 1, 
 dateMod = to_date('28.4.2013 15:36:02', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 15 

28.4.2013 15:36:02
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 15:36:06
UPDATE Login SET 
logout = to_date('28.4.2013 15:36:06', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 400 

28.4.2013 15:41:07
select * from [User] where nameLogin = @nameLogin and password = @password

28.4.2013 15:41:08
INSERT INTO Login ( idUser, 
login, 
idApplication) VALUES (  1, 
 to_date('28.4.2013 15:41:08', 'dd/mm/yyyy hh24:mi:ss'), 
 1) ; SELECT @@Identity

28.4.2013 15:41:10
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 15:41:27
INSERT INTO Modul ( nameModul, 
idParent, 
orderModul, 
sqlQuery, 
nameApplication, 
parametersApp, 
userAdd, 
dateAdd) VALUES (  'Modul 7', 
 '', 
 '100', 
 '', 
 NULL, 
 NULL, 
 1, 
 to_date('28.4.2013 15:41:27', 'dd/mm/yyyy hh24:mi:ss')) ; SELECT @@Identity

28.4.2013 15:41:30
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 15:42:01
select * from Rights where idModul = 27

28.4.2013 15:43:34
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 15:45:46
INSERT INTO Modul ( nameModul, 
idParent, 
orderModul, 
sqlQuery, 
nameApplication, 
parametersApp, 
userAdd, 
dateAdd) VALUES (  '777', 
 '', 
 '120', 
 '', 
 NULL, 
 NULL, 
 1, 
 to_date('28.4.2013 15:45:46', 'dd/mm/yyyy hh24:mi:ss')) ; SELECT @@Identity

28.4.2013 15:46:28
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 15:46:28
System.NullReferenceException: Object reference not set to an instance of an object.
   at ManagerPruzkumnik.Moduly.UCEditaceModulu.FillPanelModulInfo(Modul modul)

28.4.2013 15:46:47
select * from Rights where idModul = 28

28.4.2013 15:46:48
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 15:47:43
INSERT INTO Modul ( nameModul, 
idParent, 
orderModul, 
sqlQuery, 
nameApplication, 
parametersApp, 
userAdd, 
dateAdd) VALUES (  '777', 
 '', 
 NULL, 
 '', 
 NULL, 
 NULL, 
 1, 
 to_date('28.4.2013 15:47:43', 'dd/mm/yyyy hh24:mi:ss')) ; SELECT @@Identity

28.4.2013 15:47:45
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 15:47:45
System.NullReferenceException: Object reference not set to an instance of an object.
   at ManagerPruzkumnik.Moduly.UCEditaceModulu.FillPanelModulInfo(Modul modul)

28.4.2013 15:47:53
select * from Rights where idModul = 29

28.4.2013 15:47:54
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 15:48:22
INSERT INTO Modul ( nameModul, 
idParent, 
orderModul, 
sqlQuery, 
nameApplication, 
parametersApp, 
userAdd, 
dateAdd) VALUES (  '777', 
 '', 
 NULL, 
 '', 
 NULL, 
 NULL, 
 1, 
 to_date('28.4.2013 15:48:22', 'dd/mm/yyyy hh24:mi:ss')) ; SELECT @@Identity

28.4.2013 15:48:23
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 15:49:01
System.NullReferenceException: Object reference not set to an instance of an object.
   at ManagerPruzkumnik.Moduly.UCEditaceModulu.FillPanelModulInfo(Modul modul)

28.4.2013 15:51:00
select * from Rights where idModul = 30

28.4.2013 15:51:00
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 15:51:13
INSERT INTO Modul ( nameModul, 
idParent, 
orderModul, 
sqlQuery, 
nameApplication, 
parametersApp, 
userAdd, 
dateAdd) VALUES (  '777', 
 '', 
 NULL, 
 '', 
 NULL, 
 NULL, 
 1, 
 to_date('28.4.2013 15:51:13', 'dd/mm/yyyy hh24:mi:ss')) ; SELECT @@Identity

28.4.2013 15:51:13
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 15:51:13
System.NullReferenceException: Object reference not set to an instance of an object.
   at ManagerPruzkumnik.Moduly.UCEditaceModulu.FillPanelModulInfo(Modul modul)

28.4.2013 15:51:33
select * from Rights where idModul = 31

28.4.2013 15:51:33
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 15:53:41
INSERT INTO Modul ( nameModul, 
idParent, 
orderModul, 
sqlQuery, 
nameApplication, 
parametersApp, 
userAdd, 
dateAdd) VALUES (  '777', 
 '', 
 NULL, 
 '', 
 NULL, 
 NULL, 
 1, 
 to_date('28.4.2013 15:53:41', 'dd/mm/yyyy hh24:mi:ss')) ; SELECT @@Identity

28.4.2013 15:53:41
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 15:53:41
System.NullReferenceException: Object reference not set to an instance of an object.
   at ManagerPruzkumnik.Moduly.UCEditaceModulu.FillPanelModulInfo(Modul modul)

28.4.2013 15:53:45
select * from Rights where idModul = 32

28.4.2013 15:55:10
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 16:22:01
INSERT INTO Modul ( nameModul, 
idParent, 
orderModul, 
sqlQuery, 
nameApplication, 
parametersApp, 
userAdd, 
dateAdd) VALUES (  '7777', 
 '', 
 NULL, 
 '', 
 NULL, 
 NULL, 
 1, 
 to_date('28.4.2013 16:22:01', 'dd/mm/yyyy hh24:mi:ss')) ; SELECT @@Identity

28.4.2013 16:22:01
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 16:22:01
System.NullReferenceException: Object reference not set to an instance of an object.
   at ManagerPruzkumnik.Moduly.UCEditaceModulu.FillPanelModulInfo(Modul modul)

28.4.2013 16:22:06
select * from Rights where idModul = 33

28.4.2013 16:23:04
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 16:23:15
select * from role order by name

28.4.2013 16:23:15
select top 0  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 16:23:15
select  
NULL as idRights,
idModul,
nameModul, 
1 as idRole,
1 as idModulRights, 
1 as visible, 
1 as adding, 
1 as edit,  
1 as remove, 
1 as printing,  
1 as specialFiltration 
from Modul 
order by modul.nameModul

28.4.2013 16:23:15
--DECLARE 1 int = 1; 
select 
Rights.idRights,
Modul.idModul, Modul.nameModul, 
Rights.idRole, 
Rights.idModul as idModulRights, 
ISNULL(Rights.visible, 1) as visible, 
ISNULL(Rights.adding, 1) as adding, 
ISNULL(Rights.edit, 1) as edit,  
ISNULL(Rights.remove, 1) as remove, 
ISNULL(Rights.printing, 1) as printing,  
ISNULL(Rights.specialFiltration, 1) as specialFiltration 
from Modul 
left join Rights on Modul.idModul = Rights.idModul 
where Rights.idRole = 1 
order by modul.nameModul

28.4.2013 16:23:15
select * from role order by name

28.4.2013 16:23:37
INSERT INTO Modul ( nameModul, 
idParent, 
orderModul, 
sqlQuery, 
nameApplication, 
parametersApp, 
userAdd, 
dateAdd) VALUES (  '7777', 
 '', 
 NULL, 
 '', 
 NULL, 
 NULL, 
 1, 
 to_date('28.4.2013 16:23:37', 'dd/mm/yyyy hh24:mi:ss')) ; SELECT @@Identity

28.4.2013 16:23:37
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 16:23:37
System.NullReferenceException: Object reference not set to an instance of an object.
   at ManagerPruzkumnik.Moduly.UCEditaceModulu.FillPanelModulInfo(Modul modul)

28.4.2013 16:23:51
UPDATE Modul SET 
nameModul = '7777', 
 idParent = '0', 
 orderModul = '200', 
 sqlQuery = '', 
 nameApplication = NULL, 
 parametersApp = NULL, 
 userMod = 1, 
 dateMod = to_date('28.4.2013 16:23:51', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idModul = 34 

28.4.2013 16:23:51
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 16:23:57
select * from Rights where idModul = 34

28.4.2013 16:23:57
select Modul.*, UserAdd.nameLogin as UserNameAdd, UserMod.nameLogin as UserNameMod  
from Modul 
left join [User] as UserAdd on Modul.userAdd = UserAdd.idUser 
left join [User] as UserMod on Modul.userMod = UserMod.idUser 
order by idParent, orderModul

28.4.2013 16:26:37
UPDATE Login SET 
logout = to_date('28.4.2013 16:26:37', 'dd/mm/yyyy hh24:mi:ss')
 WHERE idLogin = 401 

